IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spOrderDetailsInsert')
	BEGIN
		DROP  PROCEDURE  spOrderDetailsInsert
	END
GO
-- =============================================
-- Author:		<NamTP>
-- Create date: <Apr 24, 2012>
-- Description:	<Get Company List Infomation>
-- TEST: EXEC spOrderDetailsInsert 17,2,''
-- =============================================
CREATE PROCEDURE spOrderDetailsInsert
	@OrderID INT
   ,@ProductID INT
   ,@UnitPrice MONEY
   ,@Quantity SMALLINT
   ,@Discount REAL
AS
BEGIN
	INSERT INTO OrderDetails([OrderID]
      ,[ProductID]
      ,[UnitPrice]
      ,[Quantity]
      ,[Discount])
    VALUES(@OrderID
   ,@ProductID
   ,@UnitPrice
   ,@Quantity
   ,@Discount)
	
END
GO
